Create Table Amzn.AmazonTemplate
(
AmazonTemplateID int identity(1,1) primary key ,
AmazonTemplateName nvarchar(50) not null,
AmazonTemplateCnName nvarchar(50),
IsDel bit default 0,
CreateUser NVARCHAR(20) DEFAULT 'PU',
CreateTime datetime default getdate(),
UpdateUser NVARCHAR(20) DEFAULT 'FL',
UpdateTime datetime default getdate()
)

Create Table Amzn.AmazonProductType
(
AmazonProductTypeID int identity(1,1) primary key ,
AmazonProductTypeName nvarchar(50) not null,
AmazonProductTypeCnName nvarchar(50) ,
IsDel bit default 0,
CreateUser NVARCHAR(20) DEFAULT 'PU',
CreateTime datetime default getdate(),
UpdateUser NVARCHAR(20) DEFAULT 'FL',
UpdateTime datetime default getdate()
)
Create Table Amzn.TemplateProductTypeRela
(
TemplateProductTypeRelaID int identity(1,1) primary key,
AmazonTemplateID int not null,
AmazonProductTypeID int not null,
Remark nvarchar(50),
IsDel bit default 0,
CreateUser NVARCHAR(20) DEFAULT 'PU',
CreateTime datetime default getdate(),
UpdateUser NVARCHAR(20) DEFAULT 'FL',
UpdateTime datetime default getdate()
)